import glob
from openpyxl import load_workbook

workbook= load_workbook(filename='D:\\sms\\python02\\工作.xlsx')
sheet= workbook['Sheet2']
for cols in sheet.rows:
    # for col in cols:
        # if(col.value.startswith('数量')):
        # for index in range(len(cols)):
        #     if (cols[index].value.startswith('数量')):
        #         print(cols[index].value)

   if cols[2].value==100 or cols[2].value.find("数量")==True:
       print(cols[2].value)
       print(1)
   else:
    print(2)